from sqlalchemy import Column, Integer, String
from database.db_init import Base


class Machine(Base):
    __tablename__ = "Machine"
    ID = Column(Integer, primary_key=True, index=True)
    EquipmentNumber = Column(String, unique=True)
    EquipmentName = Column(String, unique=False)
    Function = Column(String, unique=False)
    Status = Column(String, unique=False)
    HealthStatus = Column(String, unique=False)
    ParameterName = Column(String, unique=False)
    ParameterInfo = Column(String, unique=False)
    FarmID = Column(Integer, unique=False)
